import xlwings as xw

wb = xw.Book()
sht = wb.sheets['Sheet1']
sht.range('B2').value = [['Foo 1', 'Foo 2', 'Foo 3','Foo 4'], [10.0, 20.0, 30.0,400]]  # 批量写入
print(sht.range('A1').expand().value)  # 批量读取
#wb.save('test.xlsx')  # 保存
sht.range('A1').color=(150,0,0)

wb.save('test4.xlsx')
input('输入任意字符退出...')
wb.close()
